Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 30425 |
| Missing cells | 40565 |
| Missing cells (%) | 9.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.2 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 5 |
|---|---|
| Text | 2 |
| Unsupported | 3 |
| DateTime | 2 |
| Categorical | 2 |
Local Currency has constant value "" | Constant |
Unit Price is highly overall correlated with Total PO Value and 1 other fields | High correlation |
Total PO Value is highly overall correlated with Unit Price and 1 other fields | High correlation |
Total PO Value Local Currency is highly overall correlated with Unit Price and 1 other fields | High correlation |
PO Order Date has 20277 (66.6%) missing values | Missing |
PO Approval Date has 20267 (66.6%) missing values | Missing |
Unit Price is highly skewed (γ1 = 60.78282175) | Skewed |
Total PO Value is highly skewed (γ1 = 60.56316997) | Skewed |
Total PO Value Local Currency is highly skewed (γ1 = 60.56316997) | Skewed |
PO Identifier is uniformly distributed | Uniform |
PO Identifier has unique values | Unique |
PO Number is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Item is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Description is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unit Price has 728 (2.4%) zeros | Zeros |
Total PO Value has 728 (2.4%) zeros | Zeros |
Total PO Value Local Currency has 728 (2.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-30 04:08:32.870470 |
|---|---|
| Analysis finished | 2023-05-30 04:16:50.897891 |
| Duration | 8 minutes and 18.03 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
PO Identifier
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 30425 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15213 |
| Minimum | 1 |
|---|---|
| Maximum | 30425 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 237.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1522.2 |
| Q1 | 7607 |
| median | 15213 |
| Q3 | 22819 |
| 95-th percentile | 28903.8 |
| Maximum | 30425 |
| Range | 30424 |
| Interquartile range (IQR) | 15212 |
Descriptive statistics
| Standard deviation | 8783.0853 |
|---|---|
| Coefficient of variation (CV) | 0.57734078 |
| Kurtosis | -1.2 |
| Mean | 15213 |
| Median Absolute Deviation (MAD) | 7606 |
| Skewness | 0 |
| Sum | 4.6285552 × 108 |
| Variance | 77142588 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 768 | 1 | < 0.1% |
| 20274 | 1 | < 0.1% |
| 20286 | 1 | < 0.1% |
| 20285 | 1 | < 0.1% |
| 20284 | 1 | < 0.1% |
| 20283 | 1 | < 0.1% |
| 20282 | 1 | < 0.1% |
| 20281 | 1 | < 0.1% |
| 20280 | 1 | < 0.1% |
| 20279 | 1 | < 0.1% |
| Other values (30415) | 30415 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 30425 | 1 | |
| 30424 | 1 | |
| 30423 | 1 | |
| 30422 | 1 | |
| 30421 | 1 | |
| 30420 | 1 | |
| 30419 | 1 | |
| 30418 | 1 | |
| 30417 | 1 | |
| 30416 | 1 |
Vendor Number
Real number (ℝ)
| Distinct | 6591 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 797562.21 |
| Minimum | 0 |
|---|---|
| Maximum | 1796774 |
| Zeros | 129 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 237.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7708 |
| Q1 | 29677 |
| median | 1008971 |
| Q3 | 1249060 |
| 95-th percentile | 1749198.4 |
| Maximum | 1796774 |
| Range | 1796774 |
| Interquartile range (IQR) | 1219383 |
Descriptive statistics
| Standard deviation | 669363.93 |
|---|---|
| Coefficient of variation (CV) | 0.83926234 |
| Kurtosis | -1.5096421 |
| Mean | 797562.21 |
| Median Absolute Deviation (MAD) | 735273 |
| Skewness | -0.016852322 |
| Sum | 2.4265033 × 1010 |
| Variance | 4.4804806 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1065902 | 825 | 2.7% |
| 1001584 | 649 | 2.1% |
| 1249060 | 541 | 1.8% |
| 1087660 | 539 | 1.8% |
| 36519 | 538 | 1.8% |
| 1008361 | 459 | 1.5% |
| 1000709 | 409 | 1.3% |
| 12341 | 354 | 1.2% |
| 11527 | 298 | 1.0% |
| 1018638 | 291 | 1.0% |
| Other values (6581) | 25521 |
| Value | Count | Frequency (%) |
| 0 | 129 | |
| 39 | 22 | 0.1% |
| 45 | 1 | < 0.1% |
| 61 | 15 | < 0.1% |
| 89 | 2 | < 0.1% |
| 124 | 3 | < 0.1% |
| 143 | 2 | < 0.1% |
| 148 | 2 | < 0.1% |
| 210 | 1 | < 0.1% |
| 278 | 32 | 0.1% |
| Value | Count | Frequency (%) |
| 1796774 | 1 | < 0.1% |
| 1796486 | 3 | < 0.1% |
| 1793589 | 6 | |
| 1792944 | 2 | < 0.1% |
| 1792325 | 11 | |
| 1791874 | 1 | < 0.1% |
| 1791711 | 1 | < 0.1% |
| 1791481 | 1 | < 0.1% |
| 1791364 | 1 | < 0.1% |
| 1791228 | 1 | < 0.1% |
Vendor Name
Text
| Distinct | 2235 |
|---|---|
| Distinct (%) | 7.3% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 237.8 KiB |
Length
| Max length | 78 |
|---|---|
| Median length | 66 |
| Mean length | 23.461164 |
| Min length | 3 |
Characters and Unicode
| Total characters | 713759 |
|---|---|
| Distinct characters | 73 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1000 ? |
|---|---|
| Unique (%) | 3.3% |
Sample
| 1st row | ExLibris |
|---|---|
| 2nd row | ExLibris |
| 3rd row | Alliant Insurance Services, Inc |
| 4th row | Alliant Insurance Services, Inc |
| 5th row | EMC |
| Value | Count | Frequency (%) |
| inc | 11324 | 11.9% |
| technology | 6525 | 6.9% |
| group | 6351 | 6.7% |
| integration | 5909 | 6.2% |
| business | 5262 | 5.5% |
| products | 4630 | 4.9% |
| smile | 4073 | 4.3% |
| solutions | 2218 | 2.3% |
| corporation | 1801 | 1.9% |
| systems | 1540 | 1.6% |
| Other values (2424) | 45201 |
Most occurring characters
| Value | Count | Frequency (%) |
| 64428 | 9.0% | |
| o | 50450 | 7.1% |
| n | 49778 | 7.0% |
| e | 45842 | 6.4% |
| t | 36405 | 5.1% |
| r | 33915 | 4.8% |
| s | 33688 | 4.7% |
| i | 32698 | 4.6% |
| c | 27630 | 3.9% |
| I | 25862 | 3.6% |
| Other values (63) | 313063 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 456306 | |
| Uppercase Letter | 176635 | 24.7% |
| Space Separator | 64428 | 9.0% |
| Other Punctuation | 14967 | 2.1% |
| Decimal Number | 406 | 0.1% |
| Open Punctuation | 376 | 0.1% |
| Close Punctuation | 371 | 0.1% |
| Dash Punctuation | 269 | < 0.1% |
| Math Symbol | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 50450 | |
| n | 49778 | |
| e | 45842 | |
| t | 36405 | 8.0% |
| r | 33915 | 7.4% |
| s | 33688 | 7.4% |
| i | 32698 | 7.2% |
| c | 27630 | 6.1% |
| u | 23265 | 5.1% |
| a | 21863 | 4.8% |
| Other values (16) | 100772 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 25862 | |
| S | 19541 | |
| T | 16857 | 9.5% |
| C | 13595 | 7.7% |
| N | 10118 | 5.7% |
| E | 9849 | 5.6% |
| G | 8842 | 5.0% |
| P | 8744 | 5.0% |
| B | 8608 | 4.9% |
| A | 8498 | 4.8% |
| Other values (16) | 46121 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 271 | |
| 1 | 64 | 15.8% |
| 2 | 27 | 6.7% |
| 0 | 16 | 3.9% |
| 4 | 12 | 3.0% |
| 5 | 9 | 2.2% |
| 7 | 4 | 1.0% |
| 6 | 2 | 0.5% |
| 9 | 1 | 0.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 8752 | |
| . | 4177 | |
| & | 996 | 6.7% |
| / | 696 | 4.7% |
| ' | 344 | 2.3% |
| : | 1 | < 0.1% |
| @ | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 64428 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 376 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 371 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 269 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 632941 | |
| Common | 80818 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 50450 | 8.0% |
| n | 49778 | 7.9% |
| e | 45842 | 7.2% |
| t | 36405 | 5.8% |
| r | 33915 | 5.4% |
| s | 33688 | 5.3% |
| i | 32698 | 5.2% |
| c | 27630 | 4.4% |
| I | 25862 | 4.1% |
| u | 23265 | 3.7% |
| Other values (42) | 273408 |
Common
| Value | Count | Frequency (%) |
| 64428 | ||
| , | 8752 | 10.8% |
| . | 4177 | 5.2% |
| & | 996 | 1.2% |
| / | 696 | 0.9% |
| ( | 376 | 0.5% |
| ) | 371 | 0.5% |
| ' | 344 | 0.4% |
| 3 | 271 | 0.3% |
| - | 269 | 0.3% |
| Other values (11) | 138 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 713759 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 64428 | 9.0% | |
| o | 50450 | 7.1% |
| n | 49778 | 7.0% |
| e | 45842 | 6.4% |
| t | 36405 | 5.1% |
| r | 33915 | 4.8% |
| s | 33688 | 4.7% |
| i | 32698 | 4.6% |
| c | 27630 | 3.9% |
| I | 25862 | 3.6% |
| Other values (63) | 313063 |
PO Number
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 237.8 KiB |
PO Approver
Text
| Distinct | 26110 |
|---|---|
| Distinct (%) | 85.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 237.8 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 24 |
| Mean length | 13.272145 |
| Min length | 6 |
Characters and Unicode
| Total characters | 403805 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 23237 ? |
|---|---|
| Unique (%) | 76.4% |
Sample
| 1st row | Denise Rivers |
|---|---|
| 2nd row | Denise Rivers |
| 3rd row | Denise Rivers |
| 4th row | Denise Rivers |
| 5th row | Denise Rivers |
| Value | Count | Frequency (%) |
| michael | 696 | 1.1% |
| smith | 634 | 1.0% |
| johnson | 544 | 0.9% |
| james | 526 | 0.8% |
| david | 470 | 0.8% |
| jennifer | 465 | 0.7% |
| williams | 427 | 0.7% |
| john | 426 | 0.7% |
| thomas | 412 | 0.7% |
| christopher | 403 | 0.6% |
| Other values (1585) | 57240 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 37578 | 9.3% |
| a | 37073 | 9.2% |
| 31818 | 7.9% | |
| n | 30358 | 7.5% |
| r | 29219 | 7.2% |
| i | 24537 | 6.1% |
| o | 21867 | 5.4% |
| l | 20465 | 5.1% |
| s | 18236 | 4.5% |
| t | 14111 | 3.5% |
| Other values (43) | 138543 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 308083 | |
| Uppercase Letter | 63268 | 15.7% |
| Space Separator | 31818 | 7.9% |
| Other Punctuation | 636 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 37578 | |
| a | 37073 | |
| n | 30358 | |
| r | 29219 | |
| i | 24537 | |
| o | 21867 | 7.1% |
| l | 20465 | 6.6% |
| s | 18236 | 5.9% |
| t | 14111 | 4.6% |
| h | 13377 | 4.3% |
| Other values (16) | 61262 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 7332 | |
| J | 6139 | 9.7% |
| S | 5103 | 8.1% |
| C | 4701 | 7.4% |
| D | 4305 | 6.8% |
| A | 3890 | 6.1% |
| B | 3882 | 6.1% |
| R | 3833 | 6.1% |
| H | 2985 | 4.7% |
| W | 2964 | 4.7% |
| Other values (15) | 18134 |
Space Separator
| Value | Count | Frequency (%) |
| 31818 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 636 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 371351 | |
| Common | 32454 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 37578 | 10.1% |
| a | 37073 | 10.0% |
| n | 30358 | 8.2% |
| r | 29219 | 7.9% |
| i | 24537 | 6.6% |
| o | 21867 | 5.9% |
| l | 20465 | 5.5% |
| s | 18236 | 4.9% |
| t | 14111 | 3.8% |
| h | 13377 | 3.6% |
| Other values (41) | 124530 |
Common
| Value | Count | Frequency (%) |
| 31818 | ||
| . | 636 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 403805 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 37578 | 9.3% |
| a | 37073 | 9.2% |
| 31818 | 7.9% | |
| n | 30358 | 7.5% |
| r | 29219 | 7.2% |
| i | 24537 | 6.1% |
| o | 21867 | 5.4% |
| l | 20465 | 5.1% |
| s | 18236 | 4.5% |
| t | 14111 | 3.5% |
| Other values (43) | 138543 |
PO Order Date
Date
| Distinct | 451 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 20277 |
| Missing (%) | 66.6% |
| Memory size | 237.8 KiB |
| Minimum | 1913-10-10 00:00:00 |
|---|---|
| Maximum | 2021-06-06 00:00:00 |
Histogram with fixed size bins (bins=50)
PO Approval Date
Date
| Distinct | 459 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 20267 |
| Missing (%) | 66.6% |
| Memory size | 237.8 KiB |
| Minimum | 1913-10-10 00:00:00 |
|---|---|
| Maximum | 2021-06-06 00:00:00 |
Histogram with fixed size bins (bins=50)
Item
Unsupported
REJECTED UNSUPPORTED
| Missing | 1 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 237.8 KiB |
Description
Unsupported
REJECTED UNSUPPORTED
| Missing | 16 |
|---|---|
| Missing (%) | 0.1% |
| Memory size | 237.8 KiB |
Unit Price
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 15131 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50891.452 |
| Minimum | -195915.9 |
|---|---|
| Maximum | 97106933 |
| Zeros | 728 |
| Zeros (%) | 2.4% |
| Negative | 76 |
| Negative (%) | 0.2% |
| Memory size | 237.8 KiB |
Quantile statistics
| Minimum | -195915.9 |
|---|---|
| 5-th percentile | 8.55 |
| Q1 | 113 |
| median | 575.83 |
| Q3 | 7255 |
| 95-th percentile | 96810.028 |
| Maximum | 97106933 |
| Range | 97302849 |
| Interquartile range (IQR) | 7142 |
Descriptive statistics
| Standard deviation | 1047316.7 |
|---|---|
| Coefficient of variation (CV) | 20.579422 |
| Kurtosis | 4358.746 |
| Mean | 50891.452 |
| Median Absolute Deviation (MAD) | 565.83 |
| Skewness | 60.782822 |
| Sum | 1.5483724 × 109 |
| Variance | 1.0968722 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 728 | 2.4% |
| 105 | 234 | 0.8% |
| 245 | 176 | 0.6% |
| 198.07 | 171 | 0.6% |
| 150 | 127 | 0.4% |
| 113 | 119 | 0.4% |
| 103.25 | 118 | 0.4% |
| 252.76 | 117 | 0.4% |
| 3712.4 | 116 | 0.4% |
| 121.33 | 103 | 0.3% |
| Other values (15121) | 28416 |
| Value | Count | Frequency (%) |
| -195915.9 | 1 | |
| -55529 | 1 | |
| -44606.57 | 1 | |
| -36626.88 | 1 | |
| -30000 | 1 | |
| -16750 | 2 | |
| -14674.49 | 1 | |
| -11651 | 1 | |
| -8732 | 1 | |
| -7980 | 1 |
| Value | Count | Frequency (%) |
| 97106933.19 | 1 | |
| 73982622 | 1 | |
| 62482622 | 1 | |
| 54000000 | 1 | |
| 52419751 | 1 | |
| 44072001 | 1 | |
| 40649810 | 1 | |
| 39500000 | 1 | |
| 28420574 | 1 | |
| 16145096 | 1 |
Total PO Value
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 17475 |
|---|---|
| Distinct (%) | 57.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53750.226 |
| Minimum | -195915.9 |
|---|---|
| Maximum | 97106933 |
| Zeros | 728 |
| Zeros (%) | 2.4% |
| Negative | 76 |
| Negative (%) | 0.2% |
| Memory size | 237.8 KiB |
Quantile statistics
| Minimum | -195915.9 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 362.1 |
| median | 1980.7 |
| Q3 | 10000 |
| 95-th percentile | 107065.3 |
| Maximum | 97106933 |
| Range | 97302849 |
| Interquartile range (IQR) | 9637.9 |
Descriptive statistics
| Standard deviation | 1048605.7 |
|---|---|
| Coefficient of variation (CV) | 19.508862 |
| Kurtosis | 4336.7462 |
| Mean | 53750.226 |
| Median Absolute Deviation (MAD) | 1908.71 |
| Skewness | 60.56317 |
| Sum | 1.6353506 × 109 |
| Variance | 1.099574 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 728 | 2.4% |
| 105 | 193 | 0.6% |
| 150 | 131 | 0.4% |
| 252.76 | 105 | 0.3% |
| 3712.4 | 102 | 0.3% |
| 4095 | 89 | 0.3% |
| 368 | 75 | 0.2% |
| 5003.26 | 71 | 0.2% |
| 534.01 | 69 | 0.2% |
| 1620 | 67 | 0.2% |
| Other values (17465) | 28795 |
| Value | Count | Frequency (%) |
| -195915.9 | 1 | |
| -55529 | 1 | |
| -44606.57 | 1 | |
| -36626.88 | 1 | |
| -30000 | 1 | |
| -25600 | 1 | |
| -16750 | 2 | |
| -14674.49 | 1 | |
| -13562 | 1 | |
| -11651 | 1 |
| Value | Count | Frequency (%) |
| 97106933.19 | 1 | |
| 73982622 | 1 | |
| 62482622 | 1 | |
| 54000000 | 1 | |
| 52419751 | 1 | |
| 44072001 | 1 | |
| 40649810 | 1 | |
| 39500000 | 1 | |
| 28420574 | 1 | |
| 16145096 | 1 |
Local Currency
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 237.8 KiB |
| SGD |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 91272 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SGD |
|---|---|
| 2nd row | SGD |
| 3rd row | SGD |
| 4th row | SGD |
| 5th row | SGD |
Common Values
| Value | Count | Frequency (%) |
| SGD | 30424 | |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| sgd | 30424 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 30424 | |
| G | 30424 | |
| D | 30424 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 91272 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 30424 | |
| G | 30424 | |
| D | 30424 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 91272 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 30424 | |
| G | 30424 | |
| D | 30424 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 91272 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 30424 | |
| G | 30424 | |
| D | 30424 |
Total PO Value Local Currency
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 17475 |
|---|---|
| Distinct (%) | 57.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53750.226 |
| Minimum | -195915.9 |
|---|---|
| Maximum | 97106933 |
| Zeros | 728 |
| Zeros (%) | 2.4% |
| Negative | 76 |
| Negative (%) | 0.2% |
| Memory size | 237.8 KiB |
Quantile statistics
| Minimum | -195915.9 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 362.1 |
| median | 1980.7 |
| Q3 | 10000 |
| 95-th percentile | 107065.3 |
| Maximum | 97106933 |
| Range | 97302849 |
| Interquartile range (IQR) | 9637.9 |
Descriptive statistics
| Standard deviation | 1048605.7 |
|---|---|
| Coefficient of variation (CV) | 19.508862 |
| Kurtosis | 4336.7462 |
| Mean | 53750.226 |
| Median Absolute Deviation (MAD) | 1908.71 |
| Skewness | 60.56317 |
| Sum | 1.6353506 × 109 |
| Variance | 1.099574 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 728 | 2.4% |
| 105 | 193 | 0.6% |
| 150 | 131 | 0.4% |
| 252.76 | 105 | 0.3% |
| 3712.4 | 102 | 0.3% |
| 4095 | 89 | 0.3% |
| 368 | 75 | 0.2% |
| 5003.26 | 71 | 0.2% |
| 534.01 | 69 | 0.2% |
| 1620 | 67 | 0.2% |
| Other values (17465) | 28795 |
| Value | Count | Frequency (%) |
| -195915.9 | 1 | |
| -55529 | 1 | |
| -44606.57 | 1 | |
| -36626.88 | 1 | |
| -30000 | 1 | |
| -25600 | 1 | |
| -16750 | 2 | |
| -14674.49 | 1 | |
| -13562 | 1 | |
| -11651 | 1 |
| Value | Count | Frequency (%) |
| 97106933.19 | 1 | |
| 73982622 | 1 | |
| 62482622 | 1 | |
| 54000000 | 1 | |
| 52419751 | 1 | |
| 44072001 | 1 | |
| 40649810 | 1 | |
| 39500000 | 1 | |
| 28420574 | 1 | |
| 16145096 | 1 |
Family Title
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 237.8 KiB |
| Office machines and their supplies and accessories | |
|---|---|
| Computer services |
Length
| Max length | 50 |
|---|---|
| Median length | 50 |
| Mean length | 34.873689 |
| Min length | 17 |
Characters and Unicode
| Total characters | 1061032 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Computer services |
|---|---|
| 2nd row | Computer services |
| 3rd row | Computer services |
| 4th row | Computer services |
| 5th row | Computer services |
Common Values
| Value | Count | Frequency (%) |
| Office machines and their supplies and accessories | 16479 | |
| Computer services | 13946 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| and | 32958 | |
| office | 16479 | |
| machines | 16479 | |
| their | 16479 | |
| supplies | 16479 | |
| accessories | 16479 | |
| computer | 13946 | |
| services | 13946 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 140712 | |
| s | 126766 | |
| 112820 | ||
| i | 96341 | 9.1% |
| c | 79862 | 7.5% |
| a | 65916 | 6.2% |
| r | 60850 | 5.7% |
| n | 49437 | 4.7% |
| p | 46904 | 4.4% |
| h | 32958 | 3.1% |
| Other values (10) | 248466 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 917787 | |
| Space Separator | 112820 | 10.6% |
| Uppercase Letter | 30425 | 2.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 140712 | |
| s | 126766 | |
| i | 96341 | |
| c | 79862 | |
| a | 65916 | 7.2% |
| r | 60850 | 6.6% |
| n | 49437 | 5.4% |
| p | 46904 | 5.1% |
| h | 32958 | 3.6% |
| f | 32958 | 3.6% |
| Other values (7) | 185083 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 16479 | |
| C | 13946 |
Space Separator
| Value | Count | Frequency (%) |
| 112820 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 948212 | |
| Common | 112820 | 10.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 140712 | |
| s | 126766 | |
| i | 96341 | |
| c | 79862 | 8.4% |
| a | 65916 | 7.0% |
| r | 60850 | 6.4% |
| n | 49437 | 5.2% |
| p | 46904 | 4.9% |
| h | 32958 | 3.5% |
| f | 32958 | 3.5% |
| Other values (9) | 215508 |
Common
| Value | Count | Frequency (%) |
| 112820 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1061032 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 140712 | |
| s | 126766 | |
| 112820 | ||
| i | 96341 | 9.1% |
| c | 79862 | 7.5% |
| a | 65916 | 6.2% |
| r | 60850 | 5.7% |
| n | 49437 | 4.7% |
| p | 46904 | 4.4% |
| h | 32958 | 3.1% |
| Other values (10) | 248466 |
| PO Identifier | Vendor Number | Unit Price | Total PO Value | Total PO Value Local Currency | Family Title | |
|---|---|---|---|---|---|---|
| PO Identifier | 1.000 | -0.005 | -0.003 | -0.009 | -0.009 | 0.117 |
| Vendor Number | -0.005 | 1.000 | -0.005 | -0.002 | -0.002 | 0.085 |
| Unit Price | -0.003 | -0.005 | 1.000 | 0.849 | 0.849 | 0.019 |
| Total PO Value | -0.009 | -0.002 | 0.849 | 1.000 | 1.000 | 0.019 |
| Total PO Value Local Currency | -0.009 | -0.002 | 0.849 | 1.000 | 1.000 | 0.019 |
| Family Title | 0.117 | 0.085 | 0.019 | 0.019 | 0.019 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| PO Identifier | Vendor Number | Vendor Name | PO Number | PO Approver | PO Order Date | PO Approval Date | Item | Description | Unit Price | Total PO Value | Local Currency | Total PO Value Local Currency | Family Title | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 768 | 1142981.0 | ExLibris | P1410545 | Denise Rivers | 2012-02-08 | 2012-02-28 | ILS Software Maintenance | Software maintenance on Aleph ILS and Catalog Enrichment. | 72329.29 | 72329.29 | SGD | 72329.29 | Computer services |
| 1 | 769 | 58066.0 | ExLibris | P1410550 | Denise Rivers | 2012-02-08 | 2012-02-28 | ILS Software Maintenance | Software maintenance on Aleph ILS and catalog enrichment. | 152389.00 | 152389.00 | SGD | 152389.00 | Computer services |
| 2 | 10467 | 1002161.0 | Alliant Insurance Services, Inc | 4500219360 | Denise Rivers | 2015-06-19 | 2015-07-09 | Insurance Extended Warranty | Insurance Extended Warranty | 82789.79 | 82789.79 | SGD | 82789.79 | Computer services |
| 3 | 10474 | 18030.0 | Alliant Insurance Services, Inc | 4500219357 | Denise Rivers | 2015-06-20 | 2015-07-10 | Insurance Extended Warranty | Insurance Extended Warranty | 153308.22 | 153308.22 | SGD | 153308.22 | Computer services |
| 4 | 12459 | 1065902.0 | EMC | 4500147774 | Denise Rivers | 2014-09-11 | 2014-10-01 | Brocade DCX switches, maintenance, migration, and installation services and supp | Brocade DCX switches, maintenance, migration, and installation services\nand support. | 180631.24 | 180631.24 | SGD | 180631.24 | Computer services |
| 5 | 12460 | 38794.0 | EMC | 4500146103 | Denise Rivers | 2014-09-15 | 2014-10-05 | Brocade DCX switches, maintenance, migration, and installation services and supp | Brocade DCX switches, maintenance, migration, and installation services\nand supp | 69430.00 | 69430.00 | SGD | 69430.00 | Computer services |
| 6 | 1068 | 1763613.0 | Plug Inn Go, Inc | 4500166573 | Michael Johnson | 2012-09-30 | 2012-10-06 | Appliance Policy Server Software Support | SWG M86 5080 Appliance Policy Server ARS | 166.67 | 500.01 | SGD | 500.01 | Computer services |
| 7 | 1069 | 17224.0 | Plug Inn Go, Inc | 4500166574 | Michael Johnson | 2012-09-26 | 2012-10-06 | Appliance Policy Server Software Support | SWG M86 5080 Appliance Policy Server ARS | 166.67 | 500.01 | SGD | 500.01 | Computer services |
| 8 | 2402 | 1743406.0 | Smile Business Products, Inc | 4500218572 | Michael Johnson | 2013-03-01 | 2013-03-11 | MX-FR23U - Data Security Kit (hard drive data encryption) | MX-FR23U - Data Security Kit (hard drive data encryption) | 252.76 | 252.76 | SGD | 252.76 | Office machines and their supplies and accessories |
| 9 | 2403 | 10803.0 | Smile Business Products, Inc | 4500218573 | Michael Johnson | 2013-03-02 | 2013-04-11 | MX-FR23U - Data Security Kit (hard drive data encryption) | MX-FR23U - Data Security Kit (hard drive data encryption) | 252.76 | 252.76 | SGD | 252.76 | Office machines and their supplies and accessories |
| PO Identifier | Vendor Number | Vendor Name | PO Number | PO Approver | PO Order Date | PO Approval Date | Item | Description | Unit Price | Total PO Value | Local Currency | Total PO Value Local Currency | Family Title | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30415 | 30416 | 12214.0 | Technology Integration Group | GP120082 | Derrick Lewis | NaT | NaT | SAMSUNG MLT-D205-CAS TONER, BLK | SAMSUNG MLT-D205-CAS TONER, BLK | 172.49 | 8279.52 | SGD | 8279.52 | Office machines and their supplies and accessories |
| 30416 | 30417 | 46690.0 | Midtown Stationers | 12-03-0740 | Bailey Elliott | NaT | NaT | Toner | Toner | 1276.20 | 1276.20 | SGD | 1276.20 | Office machines and their supplies and accessories |
| 30417 | 30418 | 1000618.0 | Pacific Copier & Computer | IN120018 | Rachel Martin | 2021-06-06 | 2021-06-06 | toner | lot | 5727.50 | 5727.50 | SGD | 5727.50 | Office machines and their supplies and accessories |
| 30418 | 30419 | 1000633.0 | Technology Integration Group | 2PA2H109 | Anthony Day | NaT | NaT | Assorted HP Toner Cartridge | Assorted HP Toner Cartridge | 319.54 | 319.54 | SGD | 319.54 | Office machines and their supplies and accessories |
| 30419 | 30420 | 1743406.0 | Technology Integration Group | 4500198630 | Evan Lyons | 2015-05-03 | 2015-05-03 | HP Toner Genuine Blk 1.6K Smart Print ctg | HP Toner Genuine Blk 1.6K Smart Print ctg | 98.01 | 588.06 | SGD | 588.06 | Office machines and their supplies and accessories |
| 30420 | 30421 | 1000633.0 | Technology Integration Group | 1PA2L029 & 30 | Louis Long | NaT | NaT | 4y NB Exchange Warranty | 4y NB Exchange Warranty | 57.75 | 115.50 | SGD | 115.50 | Computer services |
| 30421 | 30422 | 56613.0 | Capital Datacorp | 3167436 | James Lewis | NaT | NaT | software maintenance | software maintenance | 14991.59 | 14991.59 | SGD | 14991.59 | Computer services |
| 30422 | 30423 | 17520.0 | THE PRIMARY SOURCE | CD0062812 | Rhonda Sanders | NaT | NaT | HP #91 Maintenance Ctg, Design Jet Z6100ps | HP #91 Maintenance Ctg, Design Jet Z6100ps #HEWC9518A | 74.00 | 74.00 | SGD | 74.00 | Office machines and their supplies and accessories |
| 30423 | 30424 | 56613.0 | AT&T | 30-62-016 | Mrs. Jennifer Haynes | NaT | NaT | 2 Port 3rd Gen Multiflex Trunk Voice/Wan int Card | Network Maintenance | 1100.00 | 1100.00 | SGD | 1100.00 | Computer services |
| 30424 | 30425 | 2472.0 | Enterprise Networking Solutions, Inc | 4500206683 | Brittany Hansen MD | NaT | NaT | Zerto Replication | Zerto Replication maintenance, software, and consulting services. | 48660.30 | 48660.30 | SGD | 48660.30 | Computer services |